Version

ApplyTo(WorksheetRegion[]) Method

Applies the formula to all specified regions of cells.
Syntax
public void ApplyTo( 
   WorksheetRegion[] regions
)

Parameters

regions
The regions of cells to apply the formula to.
Exceptions
ExceptionDescription
System.ArgumentNullExceptionregions is null.
System.ArgumentExceptionregions has a length of 0.
System.ArgumentException Not all regions specified are from the same worksheet.
System.InvalidOperationException One or more regions specified contain array formulas or data tables which extend outside the region.
Remarks

This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.

After this method returns, the WorksheetCell.Formula of all cells in all specified regions will return the formula.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also